# MySQL obNAbv&XgAK

## Om
* MySQL̐ݒt@C
  C\ProgramData\MySQL\MySQL Server 8.0\my.ini
  oCiO̖OĂꏊ́ulog-binvŌƕ\B

* /obNAbvꂽt@C(oCiO)̏ꏊ
  C\ProgramData\MySQL\MySQL Server 8.0\Data

* ݂̍/obNAbvɎgĂt@CmF
  irootŁjSHOW MASTER STATUS;

## K1 tobNAbv
1. WindowsϐpathύX܂B
   Rg[plVXeƃZLeBVXeVXȅڍאݒ聨ϐ
   ϐuPathvNbNAuҏWvuVKv
   uC:\Program Files\MySQL\MySQL Server 8.0\bin\vƓ͂AuOKv
   ˂ɂAR}hvvgłȂumysqlvR}hsł悤ɂȂ܂B
     i܂ł́Acd "C:\Program Files\MySQL\MySQL Server 8.0\bin\" smysqluĂtH_ɈړȂƎsłȂj

2. ȉ̃R}hR}hvvgŎs܂B
   mysqldump --lock-all-tables -A -uroot -p<root[ŨpX[h> > C:\Users\Owner\Desktop\backup_test.sql

## K1
ȉ̗vɏ]Af[^x[XobNAbvĂB
* vF
	* ۑꏊFuhLgvtH_
	* ۑΏہFrezodbû݁v
	* obNAbvt@CFbackup_<t>_<O[}1>-<[}>.sql
	* mysqldump̃IvVF--flush-logsA--lock-all-tablesA-uA-p
* qgF
	* mysqldumṕu-Av́uׂẴf[^x[XvƂӖB
	* mysqlR}hŁArezodbɃANZXƂɂǂɁurezodbvƓ͂H
	* IvV̈Ӗcu--flush-logsv=oCiO[e[giȍ~̑͐VoCiOɕۑj
	                    u--lock-all-tablesv=̓삪sĂŒ́AׂẴe[ubN
* oF
	* backup_<t>_<O[}1>-<[}>.sql
	  jbackup_20200414_m-yoshida.sql
## K2 obNAbv
1. ǂ̃[Ułǂ̂rezodbɃANZXAuser_tableɈȉ̃f[^ǉĂB
INSERT INTO user_table VALUES (4, '<̖>', '01234567890');

2. ȉ̃R}hR}hvvgŎs܂B
   mysqlbinlog "C:\ProgramData\MySQL\MySQL Server 8.0\Data\<oCiOt@C>" > C:\Users\Owner\Desktop\backup_test2.sql

## K2
ȉ̗vɏ]Af[^x[XobNAbvĂB
* vF
	* ۑꏊFuhLgvtH_
	* ۑΏہF݂̍obNAbv
	* obNAbvt@CFbackup2_<t>_<O[}1>-<[}>.sql
* oF
	* backup2_<t>_<O[}1>-<[}>.sql
	
## K3 XgA

ӁI@OɁALtH_ɕۑobNAbv݂邱ƁAeςɂȂĂȂi2̃obNAbvt@CTCYɂȂĂȂjmFĂB

1. rootrezodbɃOCAȉ̃R}hsĂB
   SHOW TABLES FROM rezodb;

2. ׂẴe[u폜܂Bȉ̃R}hAe[usĂB
   DROP TABLES <e[u>;

3. f[^x[XXgA܂B
   \qmysql甲oAȉ̃R}hs܂B
   mysql -uroot -p<rootpX[h> rezodb < <LtH_ɕۑtobNAbṽtpX>

4. XgAf[^x[XtobNAbv̂̂ɂȂĂ邩mF܂B
   user_table̓emFĂB

5. obNAbv̓eXgA܂B
   \qmysql甲oAȉ̃R}hs܂B
   mysql -uroot -p<rootpX[h> rezodb < <LtH_ɕۑobNAbṽtpX>

6. XgAf[^x[XobNAbv̂̂ɂȂĂ邩mF܂B
   user_table̓emFĂB

7. {̑SobNAbv쐬ĂB
* vF
	* ۑꏊFuhLgvtH_
	* ۑΏہFrezodbû݁v
	* obNAbvt@CFbackup3_<t>_<O[}1>-<[}>.sql
	* mysqldump̃IvVF--flush-logsA--lock-all-tablesA-uA-p
* oF
	* backup3_<t>_<O[}1>-<[}>.sql
